referential integrity

Referential integrity between tables is enforced by default when you create a relationship.

创建关系时,默认情况下将强制表与表之间的引用完整性.

互联网摘选

Copy tables, data, stored procedures, referential integrity constraints, security, and indexes. Specify the object ( s) to copy.

复制表、数据、存储过程、引用完整性约束、安全性和索引。请指定要复制的对象。

互联网摘选

Recommendation: Use the "no load" option for nicknames with referential integrity constraints and load the target table outside of the replication administration tools.

推荐：为带有参照完整性约束的别名使用“no load”选项，并在复制管理工具外部装入目标表。

互联网摘选

Delete a foreign key constraint when you want to remove the requirement to enforce referential integrity.

如果想要移除对强制引用完整性的要求,则可删除外键约束.

网络文摘精选

Describes requirements for enforcing referential integrity and the effect this has on database users.

说明强制引用完整性的要求以及对数据库用户的影响.

互联网摘选

Referential integrity constraints are not replicated, indexes are optionally replicated.

不会复制引用完整性约束，可以选择复制索引。

provided by jukuu

Create triggers to enforce referential integrity.

创建用于实施参照完整性的触发器.

互联网摘选

You can change the conditions under which referential integrity is enforced by editing the relationship's properties.

通过编辑关系的属性,可以更改强制引用完整性的条件.

互联网摘选

Referential integrity constraints enforce the relational structure of the database.

参照完整性约束可以加强数据库的关系结构。

provided by jukuu

A foreign key constraint allows you to define referential integrity between a parent and child table.

外键约束允许您定义父表和子表之间的引用完整性.

互联网摘选

Before committing a transaction, the database server verifies that referential integrity is maintained by checking the number of orphans your transaction has created.

提交事务之前，数据库服务器将通过检查您的事务产生的遗孤数来校验是否保持了参照完整性。

provided by jukuu

Even though referential integrity and check constraints are very helpful during the ETL process to help detect data problems, implementing them on final data warehouse tables is not efficient.

在ETL过程中，即时参照完整性和检查约束极其有助于检测数据问题，在最终的数据仓库表中实现它们也不会高效。

互联网摘选

Add the code to enforce referential integrity.

添加代码以强制实施参照完整性.

互联网摘选

Replication to non-DB2 target tables with referential integrity constraints is supported only if you manually define the constraints on the corresponding nicknames.

只有在相应别名上手工定义约束，才支持到带有参照完整性约束的非DB2目标表的复制。

互联网摘选

For tables that use cascading referential integrity constraints, such as the on delete cascade clause and the on update cascade clause, replication now supports merge operations on precomputed partitions.

现在，对于使用级联引用完整性约束（例如，ondeletecascade子句和onupdatecascade子句）的表，复制支持预计算分区上的合并操作。

provided by jukuu

In the conversion process, it ensures the entity integrity of the data, domain integrity and referential integrity.

在转换过程中保证了数据的实体完整性、域完整性以及引用完整性。

互联网摘选

STEP E: Define appropriate referential integrity constraints between the fact table and the three dimension tables.

第5步：在事实表和3个维度表之间建立正确的引用完整性约束。

互联网摘选

Tables that aren't bold aren't related to the filtered table with referential integrity enforced.

以非粗体格式列出的表与筛选器表没有实施参照完整性关系.

网络文摘精选

The data volumes in data warehouse databases make traditional referential integrity constraints too costly.

数据仓库中的数据量使得传统引用完整性约束的成本太高。

互联网摘选

During such operations, the database also maintains referential integrity constraints.

重用表中的空闲空间，新旧数据交叉存放，维持完整性约束。

互联网摘选

The conversion process can retain the relational database's entity integrity constraint referential integrity constraint and most of customing integrity constraint.

转换过程可保留关系数据库的实体完整性约束、参照完整性约束和绝大部分的用户自定义完整性约束。

互联网摘选

The tables listed in bold are related to the filtered table referential integrity enforced.

以粗体列出的表与过滤器表具有实施参照完整性关系.

互联网摘选

Do not include any clauses defining declarative referential integrity constraints.

不要包括可定义声明引用完整性约束的子句。

互联网摘选

You need to add the code to enforce referential integrity.

需要添加实施参照完整性的代码.

互联网摘选

Think of transaction handling and referential integrity.

考虑一下事务处理和引用完整性，就能够明白这有多么困难。

互联网摘选

This table uses referential integrity constraints to ensure data validity.

这个表使用引用完整性约束确保数据的有效性。

互联网摘选

A foreign-key constraint can implement referential integrity between parent and child tables.

外部索引键条件约束可于父和子资料表之间实作参考完整性.

互联网摘选

Also, the Q Apply program does not drop referential integrity constraints on nicknames during the loading process and then restore them.

同样，在执行装入操作期间，Q Apply程序也不删除别名上的参照完整性约束，并在这之后恢复它们。

互联网摘选

Both entity integrity and referential integrity based on primary key are two important kinds of constraint.

求解关系模式的候选键是关系模型设计的基础，基于关键字的实体完整性和引用完整性是最基本的约束，也是最重要的约束。

互联网摘选

A foreign key is a constraint that enforces referential integrity.

外键是强制引用完整性的约束.

互联网摘选